﻿CREATE PROCEDURE [acms].[UserSecurity_GetByUserName]
	@UserName varchar(50),
	@SiteId int
AS
	SELECT *
	From UserSecurity_View
	Where UserName = @UserName
		and isNull(SiteId, @SiteId) = @SiteId
	
RETURN 0;